🎖️GitЯра🎖️
Node / meshtastic / Meshtastic-Android / files / core / database / src / main / kotlin / org / meshtastic / core / database / dao / PacketDao.kt
Displaying Raw • Download
core/database/src/main/kotlin/org/meshtastic/core/database/dao/PacketDao.kt 1c3784235e7e20ed88e054097d2e7addbff92dc3 (1c378423) Text, 10.86 KB
T8b949e/*
* Copyright (c) 2025 Meshtastic LLC
*
* This program is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation, either version 3 of the License, or
* (at your option) any later version.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program. If not, see <https://www.gnu.org/licenses/>.
*/
Tff7b72package T7ee787org.meshtastic.core.database.dao
Tff7b72import T7ee787androidx.paging.PagingSource
Tff7b72import T7ee787androidx.room.Dao
Tff7b72import T7ee787androidx.room.MapColumn
Tff7b72import T7ee787androidx.room.Query
Tff7b72import T7ee787androidx.room.Transaction
Tff7b72import T7ee787androidx.room.Update
Tff7b72import T7ee787androidx.room.Upsert
Tff7b72import T7ee787kotlinx.coroutines.flow.Flow
Tff7b72import T7ee787org.meshtastic.core.database.entity.ContactSettings
Tff7b72import T7ee787org.meshtastic.core.database.entity.Packet
Tff7b72import T7ee787org.meshtastic.core.database.entity.PacketEntity
Tff7b72import T7ee787org.meshtastic.core.database.entity.ReactionEntity
Tff7b72import T7ee787org.meshtastic.core.model.DataPacket
Tff7b72import T7ee787org.meshtastic.core.model.MessageStatus
Tff7b72import T7ee787org.meshtastic.proto.ChannelProtos.ChannelSettings
Tf0883e@SuppressTb4b4b4(Ta5d6ff"Ta5d6ffTooManyFunctionsTa5d6ff"Tb4b4b4)
Tf0883e@Dao
Tff7b72interface T56d364PacketDao Tb4b4b4{
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = :portNum
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetAllPacketsTb4b4b4(Te6edf3portNumTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketTff7b72>Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetContactKeysTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<
Te6edf3MapTff7b72<
Tf0883e@MapColumnTb4b4b4(Te6edf3columnName Tff7b72= Ta5d6ff"Ta5d6ffcontact_keyTa5d6ff"Tb4b4b4)
Tffa657StringTb4b4b4,
Te6edf3PacketTb4b4b4,
Tff7b72>Tb4b4b4,
Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT p.* FROM packet p
INNER JOIN (
SELECT contact_key, MAX(received_time) as max_time
FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1
GROUP BY contact_key
) latest ON p.contact_key = latest.contact_key AND p.received_time = latest.max_time
WHERE (p.myNodeNum = 0 OR p.myNodeNum = (SELECT myNodeNum FROM my_node))
AND p.port_num = 1
ORDER BY p.received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetContactKeysPagedTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3PagingSourceTff7b72<Tffa657IntTb4b4b4, Te6edf3PacketTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetMessageCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetUnreadCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Tffa657Int
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT uuid FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0
ORDER BY received_time ASC
LIMIT 1
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetFirstUnreadMessageUuidTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657Long?Tff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) > 0 FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffhasUnreadMessagesTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657BooleanTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT COUNT(*) FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND read = 0
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetUnreadCountTotalTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Tffa657IntTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff UPDATE packet
SET read = 1
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact AND read = 0 AND received_time <= :timestamp
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffclearUnreadCountTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4, Te6edf3timestampTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@Upsert Tff7b72suspend Tff7b72fun Td2a8ffinsertTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4)
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<Te6edf3ListTff7b72<Te6edf3PacketEntityTff7b72>Tff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 1 AND contact_key = :contact
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72fun Td2a8ffgetMessagesFromPagedTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3PagingSourceTff7b72<Tffa657IntTb4b4b4, Te6edf3PacketEntityTff7b72>
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND data = :data
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8fffindDataPacketTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packet WHERE uuid in (:uuidList)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeletePacketsTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff DELETE FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND contact_key IN (:contactList)
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteContactsTb4b4b4(Te6edf3contactListTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packet WHERE uuid=:uuidTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteTb4b4b4(Te6edf3uuidTb4b4b4: Tffa657LongTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4) Tb4b4b4{
Te6edf3deleteTb4b4b4(Te6edf3packetTb4b4b4.Te6edf3uuidTb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT packet_id FROM packet WHERE uuid IN (:uuidList)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketIdsFromTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM reactions WHERE reply_id IN (:packetIds)Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteReactionsTb4b4b4(Te6edf3packetIdsTb4b4b4: Te6edf3ListTff7b72<Tffa657IntTff7b72>Tb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteMessagesTb4b4b4(Te6edf3uuidListTb4b4b4: Te6edf3ListTff7b72<Tffa657LongTff7b72>Tb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3packetIds Tff7b72= Te6edf3getPacketIdsFromTb4b4b4(Te6edf3uuidListTb4b4b4)
Tff7b72if Tb4b4b4(Te6edf3packetIdsTb4b4b4.Te6edf3isNotEmptyTb4b4b4(Tb4b4b4)Tb4b4b4) Tb4b4b4{
Te6edf3deleteReactionsTb4b4b4(Te6edf3packetIdsTb4b4b4)
Tb4b4b4}
Te6edf3deletePacketsTb4b4b4(Te6edf3uuidListTb4b4b4)
Tb4b4b4}
Tf0883e@Update Tff7b72suspend Tff7b72fun Td2a8ffupdateTb4b4b4(Te6edf3packetTb4b4b4: Te6edf3PacketTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffupdateMessageStatusTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4, Te6edf3mTb4b4b4: Te6edf3MessageStatusTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3new Tff7b72= Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3status Tff7b72= Te6edf3mTb4b4b4)
Te6edf3findDataPacketTb4b4b4(Te6edf3dataTb4b4b4)Tff7b72?.Te6edf3let Tb4b4b4{ Te6edf3updateTb4b4b4(Tffa657itTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3data Tff7b72= Te6edf3newTb4b4b4)Tb4b4b4) Tb4b4b4}
Tb4b4b4}
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffupdateMessageIdTb4b4b4(Te6edf3dataTb4b4b4: Te6edf3DataPacketTb4b4b4, Te6edf3idTb4b4b4: Tffa657IntTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3new Tff7b72= Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3id Tff7b72= Te6edf3idTb4b4b4)
Te6edf3findDataPacketTb4b4b4(Te6edf3dataTb4b4b4)Tff7b72?.Te6edf3let Tb4b4b4{ Te6edf3updateTb4b4b4(Tffa657itTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3data Tff7b72= Te6edf3newTb4b4b4)Tb4b4b4) Tb4b4b4}
Tb4b4b4}
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT data FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetDataPacketsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DataPacketTff7b72>
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND packet_id = :requestId
ORDER BY received_time DESC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketByIdTb4b4b4(Te6edf3requestIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3Packet?
Tf0883e@Transaction
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM packet WHERE packet_id = :packetId LIMIT 1Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetPacketByPacketIdTb4b4b4(Te6edf3packetIdTb4b4b4: Tffa657IntTb4b4b4)Tb4b4b4: Te6edf3PacketEntity?
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffgetQueuedPacketsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3DataPacketTff7b72>Tff7b72? Tff7b72= Te6edf3getDataPacketsTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3filter Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3status Tff7b72=Tff7b72= Te6edf3MessageStatusTb4b4b4.Te6edf3QUEUED Tb4b4b4}
Tf0883e@QueryTb4b4b4(
Ta5d6ff"""
Ta5d6ff SELECT * FROM packet
WHERE (myNodeNum = 0 OR myNodeNum = (SELECT myNodeNum FROM my_node))
AND port_num = 8
ORDER BY received_time ASC
Ta5d6ff"""Tb4b4b4,
Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetAllWaypointsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketTff7b72>
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteWaypointTb4b4b4(Te6edf3idTb4b4b4: Tffa657IntTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3uuidList Tff7b72= Te6edf3getAllWaypointsTb4b4b4(Tb4b4b4)Tb4b4b4.Te6edf3filter Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3waypointTff7b72?.Te6edf3id Tff7b72=Tff7b72= Te6edf3id Tb4b4b4}Tb4b4b4.Te6edf3map Tb4b4b4{ Tffa657itTb4b4b4.Te6edf3uuid Tb4b4b4}
Te6edf3deleteMessagesTb4b4b4(Te6edf3uuidListTb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM contact_settingsTa5d6ff"Tb4b4b4)
Tff7b72fun Td2a8ffgetContactSettingsTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3FlowTff7b72<
Te6edf3MapTff7b72<
Tf0883e@MapColumnTb4b4b4(Te6edf3columnName Tff7b72= Ta5d6ff"Ta5d6ffcontact_keyTa5d6ff"Tb4b4b4)
Tffa657StringTb4b4b4,
Te6edf3ContactSettingsTb4b4b4,
Tff7b72>Tb4b4b4,
Tff7b72>
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM contact_settings WHERE contact_key = :contactTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetContactSettingsTb4b4b4(Te6edf3contactTb4b4b4: Tffa657StringTb4b4b4)Tb4b4b4: Te6edf3ContactSettings?
Tf0883e@Upsert Tff7b72suspend Tff7b72fun Td2a8ffupsertContactSettingsTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ContactSettingsTff7b72>Tb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffsetMuteUntilTb4b4b4(Te6edf3contactsTb4b4b4: Te6edf3ListTff7b72<Tffa657StringTff7b72>Tb4b4b4, Te6edf3untilTb4b4b4: Tffa657LongTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3contactList Tff7b72=
Te6edf3contactsTb4b4b4.Te6edf3map Tb4b4b4{ Te6edf3contact Tff7b72-Tff7b72>
T8b949e// Always mute
Tff7b72val Te6edf3absoluteMuteUntil Tff7b72=
Tff7b72if Tb4b4b4(Te6edf3until Tff7b72=Tff7b72= Tffa657LongTb4b4b4.Te6edf3MAX_VALUETb4b4b4) Tb4b4b4{
Tffa657LongTb4b4b4.Te6edf3MAX_VALUE
Tb4b4b4} Tff7b72else Tff7b72if Tb4b4b4(Te6edf3until Tff7b72=Tff7b72= T79c0ff0LTb4b4b4) Tb4b4b4{ T8b949e// unmute
T79c0ff0L
Tb4b4b4} Tff7b72else Tb4b4b4{
Te6edf3SystemTb4b4b4.Te6edf3currentTimeMillisTb4b4b4(Tb4b4b4) Tff7b72+ Te6edf3until
Tb4b4b4}
Te6edf3getContactSettingsTb4b4b4(Te6edf3contactTb4b4b4)Tff7b72?.Te6edf3copyTb4b4b4(Te6edf3muteUntil Tff7b72= Te6edf3absoluteMuteUntilTb4b4b4)
Tff7b72?: Te6edf3ContactSettingsTb4b4b4(Te6edf3contact_key Tff7b72= Te6edf3contactTb4b4b4, Te6edf3muteUntil Tff7b72= Te6edf3absoluteMuteUntilTb4b4b4)
Tb4b4b4}
Te6edf3upsertContactSettingsTb4b4b4(Te6edf3contactListTb4b4b4)
Tb4b4b4}
Tf0883e@Upsert Tff7b72suspend Tff7b72fun Td2a8ffinsertTb4b4b4(Te6edf3reactionTb4b4b4: Te6edf3ReactionEntityTb4b4b4)
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllTb4b4b4(Tb4b4b4) Tb4b4b4{
Te6edf3deleteAllPacketsTb4b4b4(Tb4b4b4)
Te6edf3deleteAllReactionsTb4b4b4(Tb4b4b4)
Te6edf3deleteAllContactSettingsTb4b4b4(Tb4b4b4)
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM packetTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllPacketsTb4b4b4(Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM reactionsTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllReactionsTb4b4b4(Tb4b4b4)
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffDELETE FROM contact_settingsTa5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffdeleteAllContactSettingsTb4b4b4(Tb4b4b4)
T8b949e/**
* One-time migration: Remap all message DataPacket.channel indices to new mapping using PSK after a channel
* reorder. For each Packet (with port_num = 1), finds the old PSK then sets the channel index to the matching
* newSettings index. Skips if PSKs do not match or are missing.
*/
Tf0883e@Transaction
Tff7b72suspend Tff7b72fun Td2a8ffmigrateChannelsByPSKTb4b4b4(Te6edf3oldSettingsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ChannelSettingsTff7b72>Tb4b4b4, Te6edf3newSettingsTb4b4b4: Te6edf3ListTff7b72<Te6edf3ChannelSettingsTff7b72>Tb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3pskToNewIndex Tff7b72= Te6edf3newSettingsTb4b4b4.Te6edf3mapIndexed Tb4b4b4{ Te6edf3idxTb4b4b4, Te6edf3ch Tff7b72-Tff7b72> Te6edf3chTb4b4b4.Te6edf3psk Te6edf3to Te6edf3idx Tb4b4b4}Tb4b4b4.Te6edf3toMapTb4b4b4(Tb4b4b4)
Tff7b72val Te6edf3allPackets Tff7b72= Te6edf3getAllUserPacketsForMigrationTb4b4b4(Tb4b4b4)
Tff7b72for Tb4b4b4(Te6edf3packet Tff7b72in Te6edf3allPacketsTb4b4b4) Tb4b4b4{
Tff7b72val Te6edf3oldIndex Tff7b72= Te6edf3packetTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3channel
Tff7b72val Te6edf3oldPSK Tff7b72= Te6edf3oldSettingsTb4b4b4.Te6edf3getOrNullTb4b4b4(Te6edf3oldIndexTb4b4b4)Tff7b72?.Te6edf3psk
Tff7b72val Te6edf3newIndex Tff7b72= Tff7b72if Tb4b4b4(Te6edf3oldPSK Tff7b72!Tff7b72= Tff7b72nullTb4b4b4) Te6edf3pskToNewIndexTff7b72[Te6edf3oldPSKTff7b72] Tff7b72else Tff7b72null
Tff7b72if Tb4b4b4(Te6edf3oldPSK Tff7b72!Tff7b72= Tff7b72null Tff7b72&Tff7b72& Te6edf3newIndex Tff7b72!Tff7b72= Tff7b72null Tff7b72&Tff7b72& Te6edf3oldIndex Tff7b72!Tff7b72= Te6edf3newIndexTb4b4b4) Tb4b4b4{
T8b949e// Rebuild contact_key with the new index, keeping the rest unchanged
Tff7b72val Te6edf3oldKeySuffix Tff7b72= Te6edf3packetTb4b4b4.Te6edf3contact_keyTb4b4b4.Te6edf3dropTb4b4b4(T79c0ff1Tb4b4b4) T8b949e// removes only the channelIndex prefix
Tff7b72val Te6edf3newContactKey Tff7b72= Ta5d6ff"Tffd700$Te6edf3newIndexTffd700$Te6edf3oldKeySuffixTa5d6ff"
Te6edf3updateTb4b4b4(Te6edf3packetTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3contact_key Tff7b72= Te6edf3newContactKeyTb4b4b4, Te6edf3data Tff7b72= Te6edf3packetTb4b4b4.Te6edf3dataTb4b4b4.Te6edf3copyTb4b4b4(Te6edf3channel Tff7b72= Te6edf3newIndexTb4b4b4)Tb4b4b4)Tb4b4b4)
Tb4b4b4}
Tb4b4b4}
Tb4b4b4}
Tf0883e@QueryTb4b4b4(Ta5d6ff"Ta5d6ffSELECT * FROM packet WHERE port_num = 1Ta5d6ff"Tb4b4b4)
Tff7b72suspend Tff7b72fun Td2a8ffgetAllUserPacketsForMigrationTb4b4b4(Tb4b4b4)Tb4b4b4: Te6edf3ListTff7b72<Te6edf3PacketTff7b72>
Tb4b4b4}
Served by rngit 1.5.0 - Generated in 0.13s